﻿SELECT login_name, COUNT(session_id) as NumberSessions
FROM sys.dm_exec_sessions GROUP BY login_name


SELECT * FROM
sys.dm_io_virtual_file_stats(DB_ID(‘AdventureWorks2008’),
FILE_ID(‘AdventureWorks2008_Data’))